How to: Automatically back up files in Excel.
Solution:
Select 'Save As...' from the 'File' menu, click 'Options...' from the 'Save As' dialog box, and select the 'Always Create Backup' check box.
1) Select the 'File' menu and select 'Save As...'. (The Save As dialog box appears.)
2) Click 'Options...'. (The Save Options dialog box appears.)
the Options... button
3) Select the 'Always Create Backup' check box.
the Always Create Backup check box
4) Click 'OK'. (The Save As dialog box reappears.)
5) Click 'OK'.
NOTE: Backup copies of files are stored in the same directory as the originals but have an extension of .BAK.
